2013-06-17 - 7567.100 - Spec - OPP300 - Report not displaying all data #CrystalReportsSupport

SPECIFICATIONS

7567.100 - OPP300 : Report not displaying all data

Requirement Summary

Report OPP300 (All open orders for forecasting) is not displaying all data after being moved to the NEW BI. It was working perfectly in the old BI. It needs to be investigated and fixed.

Admin Info

Purpose	Report not displaying all data
Requested By	John Fridmann
Spec Created By	Naga Brahmam R
Spec Created Date	06/17/2013
Spec QA by	Uday Kumar P
Objects	OPP300
Document Status	Complete

References

Prior Tickets

7567.200

Documents

None

Functional Requirement

Prior OPP300 report was showing data perfectly in BOBJ 3.1 Enterprise server. After moving the report to New BOBI 4.0 Enterprise server it is not displaying all the data.

Solution Summary

1. Need to create a new report from the scratch using the same data source and check it.
2. Need to check in Crystal Report 2008 report in Crystal Report 2011 designer and refresh the report.
3. Check report by creating reports on individual tables and link after creating the report.
4. Need to modify the Infoset from Local to Global in development environment.
5. Need to create report based on Global Infosets and check if it is fetching correct results.
6. Need to modify the record selection formula and check the report output.

Test Plan

SNo	Test Scenario	Expected Results
1	Report Format.	As per NEC standards.
2	Execute Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
3	Scheduling the Report in NEC BI Launch Pad.	Report should execute successfully in NEC BI Launch Pad.

Solution Details

1. Need to create OPP300 report from the scratch using the same datasource by trail and run process and check the results.
2. Save old version Crystal report and opened the old version report in Crystal Report 2011 designer and refreshed the report to check the output.
3. Create reports based on single Info sets and link all the reports in a single report.
4. Change Infoset from Local to Global in development system and check the output.
5. Create a report pointing to NBD environment and use Global Infosets to check the output.
6. Modify the Record selection formula and check if the report is fetching correct results.

Issues

None